{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["C88","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"C88","index":0,"n_rows":418,"n_cols":19,"rows_kept":418,"cut":false,"hidden":false,"merged":[[417,2,417,4],[417,7,417,9]]}
["Reporting Template: 2025/26 - Intermediate City"]
[]
["MUNICIPALITY:","LIM476: Fetakgomo Tubatse Local Municipality","Select a municipality"]
["QUARTER:","Quarter 3","Select a submission quarter"]
[]
["Name:","MJ TSHILWANE","Name of person completing this report (Person Capturing)"]
["Phone Number:","013231 1000","Phone number of person completing this report (Person Capturing)"]
["Email:","mjtshilwane@ftlm.gov.za","Email address of person completing this report (Person Capturing)"]
[]
[null,"% Complete:",{"$f":"COUNTA(C13,C15,C18,C21,C24,C27,C30,C33,C36,C39,C42,C45,C48,C51,C54,C57,C60,C63,C66,C70,C73,C75,C78,C81,C84,C87,C90,C93,C96,C99,C102,C105,C109,C115,C118,C121,C125,C129,C132,C135,C140,C147:C220,C223,C226,C229,C232,C234,C236,C238,C240,C243,C246,C249,C259,C262,C265,C268,C272,C276,C279,C282,C285,C290,C293,C296,C299,C302,C305,C308,C311,C314,C317,C320,C323,C327,C331,C334,C337,C340,C344,C348,C352,C354,C357,C361,C364,C367,C371,C374,C379,C382,C385,C388,C391,C396:C416)/188","v":1},{"$f":"COUNTA(D290,D293,D296,D299,D302,D305,D308,D311,D314,D317,D320,D323,D327,D331,D334,D337,D340,D344,D348,D352,D354,D357,D361,D364,D367,D371,D374,D379,D382,D385,D388,D391)/32","v":1},{"$f":"COUNTA(E13,E15,E18,E21,E24,E27,E30,E33,E36,E39,E42,E45,E48,E51,E54,E57,E60,E63,E66,E70,E73,E75,E78,E81,E84,E87,E90,E93,E96,E99,E102,E105,E109,E115,E118,E121,E125,E129,E132,E135,E140,E223,E226,E229,E232,E234,E236,E238,E240,E243,E246,E249,E259,E262,E265,E268,E272,E276,E279,E282,E285)/61","v":1},{"$f":"COUNTA(F13,F15,F18,F21,F24,F27,F30,F33,F36,F39,F42,F45,F48,F51,F54,F57,F60,F63,F66,F70,F73,F75,F78,F81,F84,F87,F90,F93,F96,F99,F102,F105,F109,F115,F118,F121,F125,F129,F132,F135,F140)/41","v":1},{"$f":"COUNTA(G14,G16:G17,G19:G20,G22:G23,G25:G26,G28:G29,G31:G32,G34:G35,G37:G38,G40:G41,G43:G44,G46:G47,G49:G50,G52:G53,G55:G56,G58:G59,G61:G62,G64:G65,G67:G69,G71:G72,G74,G76:G77,G79:G80,G82:G83,G85:G86,G88:G89,G91:G92,G94:G95,G97:G98,G100:G101,G103:G104,G106:G108,G110:G114,G116:G117,G119:G120,G122:G124,G126:G128,G130:G131,G133:G134,G136:G139,G141:G144,G147:G220)/165","v":1},{"$f":"COUNTA(H13,H15,H18,H21,H24,H27,H30,H33,H36,H39,H42,H45,H48,H51,H54,H57,H60,H63,H66,H70,H73,H75,H78,H81,H84,H87,H90,H93,H96,H99,H102,H105,H109,H115,H118,H121,H125,H129,H132,H135,H140)/41","v":1},{"$f":"COUNTA(I14,I16:I17,I19:I20,I22:I23,I25:I26,I28:I29,I31:I32,I34:I35,I37:I38,I40:I41,I43:I44,I46:I47,I49:I50,I52:I53,I55:I56,I58:I59,I61:I62,I64:I65,I67:I69,I71:I72,I74,I76:I77,I79:I80,I82:I83,I85:I86,I88:I89,I91:I92,I94:I95,I97:I98,I100:I101,I103:I104,I106:I108,I110:I114,I116:I117,I119:I120,I122:I124,I126:I128,I130:I131,I133:I134,I136:I139,I141:I144,I147:I220)/165","v":1},{"$f":"COUNTA(J13,J15,J18,J21,J24,J27,J30,J33,J36,J39,J42,J45,J48,J51,J54,J57,J60,J63,J66,J70,J73,J75,J78,J81,J84,J87,J90,J93,J96,J99,J102,J105,J109,J115,J118,J121,J125,J129,J132,J135,J140)/41","v":1},{"$f":"COUNTA(K14,K16:K17,K19:K20,K22:K23,K25:K26,K28:K29,K31:K32,K34:K35,K37:K38,K40:K41,K43:K44,K46:K47,K49:K50,K52:K53,K55:K56,K58:K59,K61:K62,K64:K65,K67:K69,K71:K72,K74,K76:K77,K79:K80,K82:K83,K85:K86,K88:K89,K91:K92,K94:K95,K97:K98,K100:K101,K103:K104,K106:K108,K110:K114,K116:K117,K119:K120,K122:K124,K126:K128,K130:K131,K133:K134,K136:K139,K141:K144,K147:K220)/165","v":1},{"$f":"COUNTA(L13,L15,L18,L21,L24,L27,L30,L33,L36,L39,L42,L45,L48,L51,L54,L57,L60,L63,L66,L70,L73,L75,L78,L81,L84,L87,L90,L93,L96,L99,L102,L105,L109,L115,L118,L121,L125,L129,L132,L135,L140)/41","v":0.97560975609756095},{"$f":"COUNTA(M14,M16:M17,M19:M20,M22:M23,M25:M26,M28:M29,M31:M32,M34:M35,M37:M38,M40:M41,M43:M44,M46:M47,M49:M50,M52:M53,M55:M56,M58:M59,M61:M62,M64:M65,M67:M69,M71:M72,M74,M76:M77,M79:M80,M82:M83,M85:M86,M88:M89,M91:M92,M94:M95,M97:M98,M100:M101,M103:M104,M106:M108,M110:M114,M116:M117,M119:M120,M122:M124,M126:M128,M130:M131,M133:M134,M136:M139,M141:M144,M147:M220,M224:M225,M227:M228,M230:M231,M233,M235,M237,M239,M241:M242,M244:M245,M247:M248,M250:M258,M260:M261,M263:M264,M266:M267,M269:M271,M273:M275,M277:M278,M280:M281,M283:M284,M286:M287,M291:M292,M294:M295,M297:M298,M300:M301,M303:M304,M306:M307,M309:M310,M312:M313,M315:M316,M318:M319,M321:M322,M324:M326,M328:M330,M332:M333,M335:M336,M338:M339,M341:M343,M345:M347,M349:M351,M353,M355:M356,M358:M360,M362:M363,M365:M366,M368:M370,M372:M373,M375:M378,M380:M381,M383:M384,M386:M387,M389:M390,M392:M393,M396:M416)/303","v":0}]
["C88 Code","Description","Baseline (Annual Performance for 2024/25)","Medium term target (term of government","Annual target for 2025/26","1st Quarter planned output as per SDBIP","1st Quarter actual output","2nd Quarter planned output as per SDBIP","2nd Quarter actual output","3rd Quarter planned output as per SDBIP","3rd Quarter actual output","4th Quarter planned output as per SDBIP","4th Quarter actual output","Variation","Reason(s) for variation","Remedial action","Reasons for no data, if not provided","Steps undertaken, or to be undertaken, to provide data in the future","Estimated date when data will be available"]
["OUTPUT INDICATORS FOR QUARTERLY REPORTING"]
["EE1.11","Number of dwellings provided with connections to mains electricity supply by the municipality",0,null,0,0,{"$f":"IF(ISNUMBER(G14), G14, \"\")","v":0},0,{"$f":"IF(ISNUMBER(I14), I14, \"\")","v":0},0,{"$f":"IF(ISNUMBER(K14), K14, \"\")","v":0},0,{"$f":"IF(ISNUMBER(M14), M14, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F13)),NOT(ISBLANK(F13))),G13-F13,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H13)),NOT(ISBLANK(H13))),I13-H13,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J13)),NOT(ISBLANK(J13))),K13-J13,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L13)),NOT(ISBLANK(L13))),M13-L13,\"\"))))","v":0}]
["EE1.11(1)","Number of new residential supply points energised by the municipality",null,null,null,null,0,null,0,null,0]
["EE1.13","Percentage of valid customer applications for new electricity connections processed in terms of municipal service standards",0,null,0,0,{"$f":"IF(AND(ISNUMBER(G16),ISNUMBER(G17)), G16/G17, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(I16),ISNUMBER(I17)), I16/I17, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(K16),ISNUMBER(K17)), K16/K17, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(M16),ISNUMBER(M17)), M16/M17, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F15)),NOT(ISBLANK(F15))),G15-F15,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H15)),NOT(ISBLANK(H15))),I15-H15,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J15)),NOT(ISBLANK(J15))),K15-J15,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L15)),NOT(ISBLANK(L15))),M15-L15,\"\"))))","v":{"$error":"#DIV/0!"}}]
["EE1.13(1)","Number of valid customer applications for a new electricity connection processed within municipal standard timeframes",null,null,null,null,0,null,0,null,0]
["EE1.13(2)","Total number of valid customer applications for a new electricity connection processed",null,null,null,null,0,null,0,null,0]
["EE3.21","Percentage of planned maintenance performed",0,null,1,1,{"$f":"IF(AND(ISNUMBER(G19),ISNUMBER(G20)), G19/G20, \"\")","v":""},1,{"$f":"IF(AND(ISNUMBER(I19),ISNUMBER(I20)), I19/I20, \"\")","v":""},1,{"$f":"IF(AND(ISNUMBER(K19),ISNUMBER(K20)), K19/K20, \"\")","v":""},1,{"$f":"IF(AND(ISNUMBER(M19),ISNUMBER(M20)), M19/M20, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F18)),NOT(ISBLANK(F18))),G18-F18,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H18)),NOT(ISBLANK(H18))),I18-H18,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J18)),NOT(ISBLANK(J18))),K18-J18,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L18)),NOT(ISBLANK(L18))),M18-L18,\"\"))))","v":{"$error":"#VALUE!"}}]
["EE3.21(1)","Actual number of maintenance 'jobs' for planned or preventative maintenance",null,null,null,null,"R0",null,"R15753000",null,"R863 995.00"]
["EE3.21(2)","Budgeted number of maintenance 'jobs' for planned or preventative maintenance",null,null,null,null,"R72,315,000",null,"R72,315,000",null,"R72,315,000"]
["EE3.11","Percentage of unplanned outages that are restored to supply within industry standard timeframes",0,null,0,0,{"$f":"IF(AND(ISNUMBER(G22),ISNUMBER(G23)), G22/G23, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(I22),ISNUMBER(I23)), I22/I23, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(K22),ISNUMBER(K23)), K22/K23, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(M22),ISNUMBER(M23)), M22/M23, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F21)),NOT(ISBLANK(F21))),G21-F21,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H21)),NOT(ISBLANK(H21))),I21-H21,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J21)),NOT(ISBLANK(J21))),K21-J21,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L21)),NOT(ISBLANK(L21))),M21-L21,\"\"))))","v":{"$error":"#DIV/0!"}}]
["EE3.11(1)","Number of unplanned outages where 98% of affected customers are restored within 24 hours",null,null,null,null,0,null,0,null,0]
["EE3.11(2)","Total number of unplanned outages",null,null,null,null,0,null,0,null,0]
["ENV3.11","Percentage of recognised informal settlements receiving basic waste removal services",0.4,null,1,1,{"$f":"IF(AND(ISNUMBER(G25),ISNUMBER(G26)), G25/G26, \"\")","v":1},1,{"$f":"IF(AND(ISNUMBER(I25),ISNUMBER(I26)), I25/I26, \"\")","v":1},1,{"$f":"IF(AND(ISNUMBER(K25),ISNUMBER(K26)), K25/K26, \"\")","v":1},null,{"$f":"IF(AND(ISNUMBER(M25),ISNUMBER(M26)), M25/M26, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F24)),NOT(ISBLANK(F24))),G24-F24,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H24)),NOT(ISBLANK(H24))),I24-H24,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J24)),NOT(ISBLANK(J24))),K24-J24,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L24)),NOT(ISBLANK(L24))),M24-L24,\"\"))))","v":0}]
["ENV3.11(1)","Number of informal settlements receiving receiving basic waste removal services",null,null,null,null,22,null,22,null,22]
["ENV3.11(2)","The total number of recognised informal settlements",null,null,null,null,22,null,22,null,22]
["HS2.22","Average number of days taken to process building plan applications of less than 500 square meters","30 working days",null,"30 working days","30 working days",{"$f":"IF(AND(ISNUMBER(G28),ISNUMBER(G29)), G28/G29, \"\")","v":""},"30 working days",{"$f":"IF(AND(ISNUMBER(I28),ISNUMBER(I29)), I28/I29, \"\")","v":""},"30 working days",{"$f":"IF(AND(ISNUMBER(K28),ISNUMBER(K29)), K28/K29, \"\")","v":""},"30 working days",{"$f":"IF(AND(ISNUMBER(M28),ISNUMBER(M29)), M28/M29, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F27)),NOT(ISBLANK(F27))),G27-F27,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H27)),NOT(ISBLANK(H27))),I27-H27,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J27)),NOT(ISBLANK(J27))),K27-J27,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L27)),NOT(ISBLANK(L27))),M27-L27,\"\"))))","v":{"$error":"#VALUE!"}}]
["HS2.22(1)","Sum of the number of days between the date of submission of a complete building plan application to the municipality and the communication of the adjudication result of the application, for all applications less than of 500 square meters",null,null,null,null,"13 days",null,"2 days",null,"30 days"]
["HS2.22(2)","Number of building plan applications less than 500 square meters adjudicated",null,null,null,null,4,null,2,null,9]
["TR4.21","Percentage of municipal bus services 'on time'",0,null,0,0,{"$f":"IF(AND(ISNUMBER(G31),ISNUMBER(G32)), G31/G32, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(I31),ISNUMBER(I32)), I31/I32, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(K31),ISNUMBER(K32)), K31/K32, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(M31),ISNUMBER(M32)), M31/M32, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F30)),NOT(ISBLANK(F30))),G30-F30,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H30)),NOT(ISBLANK(H30))),I30-H30,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J30)),NOT(ISBLANK(J30))),K30-J30,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L30)),NOT(ISBLANK(L30))),M30-L30,\"\"))))","v":{"$error":"#DIV/0!"}}]
["TR4.21(1)","Scheduled municipal bus departures 'on time'",null,null,null,null,0,null,0,null,0]
["TR4.21(2)","Total scheduled municipal bus departures",null,null,null,null,0,null,0,null,0]
["TR5.31","Percentage of scheduled municipal bus trips that are universally accessible",0,null,0,0,{"$f":"IF(AND(ISNUMBER(G34),ISNUMBER(G35)), G34/G35, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(I34),ISNUMBER(I35)), I34/I35, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(K34),ISNUMBER(K35)), K34/K35, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(M34),ISNUMBER(M35)), M34/M35, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F33)),NOT(ISBLANK(F33))),G33-F33,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H33)),NOT(ISBLANK(H33))),I33-H33,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J33)),NOT(ISBLANK(J33))),K33-J33,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L33)),NOT(ISBLANK(L33))),M33-L33,\"\"))))","v":{"$error":"#DIV/0!"}}]
["TR5.31(1)","Number of all scheduled municipal bus trips that are universally accessible",null,null,null,null,0,null,0,null,0]
["TR5.31(2)","Total number of scheduled municipal bus trips",null,null,null,null,0,null,0,null,0]
["TR6.12","Percentage of surfaced municipal road lanes which has been resurfaced and resealed",5.0000000000000001E-3,null,0.08,0.08,{"$f":"IF(AND(ISNUMBER(G37),ISNUMBER(G38)), G37/G38, \"\")","v":{"$error":"#DIV/0!"}},0.08,{"$f":"IF(AND(ISNUMBER(I37),ISNUMBER(I38)), I37/I38, \"\")","v":{"$error":"#DIV/0!"}},0.08,{"$f":"IF(AND(ISNUMBER(K37),ISNUMBER(K38)), K37/K38, \"\")","v":{"$error":"#DIV/0!"}},0.08,{"$f":"IF(AND(ISNUMBER(M37),ISNUMBER(M38)), M37/M38, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F36)),NOT(ISBLANK(F36))),G36-F36,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H36)),NOT(ISBLANK(H36))),I36-H36,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J36)),NOT(ISBLANK(J36))),K36-J36,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L36)),NOT(ISBLANK(L36))),M36-L36,\"\"))))","v":{"$error":"#DIV/0!"}}]
["TR6.12(1)","Kilometres of municipal road lanes resurfaced and resealed",null,null,null,null,0,null,0,null,0]
["TR6.12(2)","Kilometres of surfaced municipal road lanes",null,null,null,null,0,null,0,null,0]
["TR6.13","KMs of new municipal road network",2403,null,2403,2403,{"$f":"IF(AND(ISNUMBER(G40),ISNUMBER(G41)), G40+G41, \"\")","v":""},2403,{"$f":"IF(AND(ISNUMBER(I40),ISNUMBER(I41)), I40+I41, \"\")","v":""},2403,{"$f":"IF(AND(ISNUMBER(K40),ISNUMBER(K41)), K40+K41, \"\")","v":0},2403,{"$f":"IF(AND(ISNUMBER(M40),ISNUMBER(M41)), M40+M41, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F39)),NOT(ISBLANK(F39))),G39-F39,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H39)),NOT(ISBLANK(H39))),I39-H39,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J39)),NOT(ISBLANK(J39))),K39-J39,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L39)),NOT(ISBLANK(L39))),M39-L39,\"\"))))","v":-2403}]
["TR6.13(1)","Number of kilometres of surfaced road network built",null,null,null,null,"4,5 km",null,"4,7 km",null,0]
["TR6.13(2)","Number of kilometres of unsurfaced road network built",null,null,null,null,0,null,0,null,0]
["TR6.21","Percentage of reported pothole complaints resolved within standard municipal response time","457m2%",null,1,1,{"$f":"IF(AND(ISNUMBER(G43),ISNUMBER(G44)), G43/G44, \"\")","v":{"$error":"#DIV/0!"}},1,{"$f":"IF(AND(ISNUMBER(I43),ISNUMBER(I44)), I43/I44, \"\")","v":{"$error":"#DIV/0!"}},1,{"$f":"IF(AND(ISNUMBER(K43),ISNUMBER(K44)), K43/K44, \"\")","v":{"$error":"#DIV/0!"}},1,{"$f":"IF(AND(ISNUMBER(M43),ISNUMBER(M44)), M43/M44, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F42)),NOT(ISBLANK(F42))),G42-F42,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H42)),NOT(ISBLANK(H42))),I42-H42,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J42)),NOT(ISBLANK(J42))),K42-J42,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L42)),NOT(ISBLANK(L42))),M42-L42,\"\"))))","v":{"$error":"#DIV/0!"}}]
["TR6.21(1)","Number of pothole complaints resolved within the standard time after being reported",null,null,null,null,0,null,0,null,0]
["TR6.21(2)","Number of potholes reported",null,null,null,null,0,null,0,null,0]
["WS1.11","Number of new sewer connections meeting minimum standards",0,null,0,0,{"$f":"IF(AND(ISNUMBER(G46),ISNUMBER(G47)), G46+G47, \"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(I46),ISNUMBER(I47)), I46+I47, \"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(K46),ISNUMBER(K47)), K46+K47, \"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(M46),ISNUMBER(M47)), M46+M47, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F45)),NOT(ISBLANK(F45))),G45-F45,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H45)),NOT(ISBLANK(H45))),I45-H45,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J45)),NOT(ISBLANK(J45))),K45-J45,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L45)),NOT(ISBLANK(L45))),M45-L45,\"\"))))","v":0}]
["WS1.11(1)","Number of new sewer connections to consumer units",null,null,null,null,0,null,0,null,0]
["WS1.11(2)","Number of new sewer connections to communal toilet facilities.",null,null,null,null,0,null,0,null,0]
["WS2.11","Number of new water connections meeting minimum standards",0,null,0,0,{"$f":"IF(AND(ISNUMBER(G49),ISNUMBER(G50)), G49+G50, \"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(I49),ISNUMBER(I50)), I49+I50, \"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(K49),ISNUMBER(K50)), K49+K50, \"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(M49),ISNUMBER(M50)), M49+M50, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F48)),NOT(ISBLANK(F48))),G48-F48,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H48)),NOT(ISBLANK(H48))),I48-H48,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J48)),NOT(ISBLANK(J48))),K48-J48,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L48)),NOT(ISBLANK(L48))),M48-L48,\"\"))))","v":0}]
["WS2.11(1)","Number of new water connections to piped (tap) water",null,null,null,null,0,null,0,null,0]
["WS2.11(2)","Number of new water connections to public/communal facilities.",null,null,null,null,0,null,0,null,0]
["WS3.11","Percentage of callouts responded to within 48 hours (sanitation/wastewater)",0,null,0,0,{"$f":"IF(AND(ISNUMBER(G52),ISNUMBER(G53)), G52/G53, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(I52),ISNUMBER(I53)), I52/I53, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(K52),ISNUMBER(K53)), K52/K53, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(M52),ISNUMBER(M53)), M52/M53, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F51)),NOT(ISBLANK(F51))),G51-F51,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H51)),NOT(ISBLANK(H51))),I51-H51,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J51)),NOT(ISBLANK(J51))),K51-J51,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L51)),NOT(ISBLANK(L51))),M51-L51,\"\"))))","v":{"$error":"#DIV/0!"}}]
["WS3.11(1)","Number of callouts responded to within 48 hours (sanitation/wastewater)",null,null,null,null,0,null,0,null,0]
["WS3.11(2)","Total number of callouts (sanitation/wastewater)",null,null,null,null,0,null,0,null,0]
["WS3.21","Percentage of callouts responded to within 48 hours (water)",0,null,0,0,{"$f":"IF(AND(ISNUMBER(G55),ISNUMBER(G56)), G55/G56, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(I55),ISNUMBER(I56)), I55/I56, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(K55),ISNUMBER(K56)), K55/K56, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(M55),ISNUMBER(M56)), M55/M56, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F54)),NOT(ISBLANK(F54))),G54-F54,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H54)),NOT(ISBLANK(H54))),I54-H54,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J54)),NOT(ISBLANK(J54))),K54-J54,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L54)),NOT(ISBLANK(L54))),M54-L54,\"\"))))","v":{"$error":"#DIV/0!"}}]
["WS3.21(1)","Number of callouts responded to within 48 hours (water)",null,null,null,null,0,null,0,null,0]
["WS3.21(2)","Total water service callouts received",null,null,null,null,0,null,0,null,0]
["GG1.21","Staff vacancy rate",0.5,null,0.4,0.4,{"$f":"IF(AND(ISNUMBER(G58),ISNUMBER(G59)), (G58-G59)/G58, \"\")","v":0.71128608923884518},0.4,{"$f":"IF(AND(ISNUMBER(I58),ISNUMBER(I59)), (I58-I59)/I58, \"\")","v":0.71828521434820647},0.4,{"$f":"IF(AND(ISNUMBER(K58),ISNUMBER(K59)), (K58-K59)/K58, \"\")","v":0.72389991371872309},0.4,{"$f":"IF(AND(ISNUMBER(M58),ISNUMBER(M59)), (M58-M59)/M58, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F57)),NOT(ISBLANK(F57))),G57-F57,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H57)),NOT(ISBLANK(H57))),I57-H57,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J57)),NOT(ISBLANK(J57))),K57-J57,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L57)),NOT(ISBLANK(L57))),M57-L57,\"\"))))","v":0.32389991371872306}]
["GG1.21(1)","The number of employee posts on the approved organisational structure",null,null,null,null,1143,null,1143,null,1159]
["GG1.21(2)","The number of actual employees in the municipality",null,null,null,null,330,null,322,null,320]
["GG1.22","Percentage of vacant posts filled within 6 months",0.1,null,0.1,0.1,{"$f":"IF(AND(ISNUMBER(G61),ISNUMBER(G62)), G61/G62, \"\")","v":1.4615384615384615},0.1,{"$f":"IF(AND(ISNUMBER(I61),ISNUMBER(I62)), I61/I62, \"\")","v":{"$error":"#DIV/0!"}},0.1,{"$f":"IF(AND(ISNUMBER(K61),ISNUMBER(K62)), K61/K62, \"\")","v":{"$error":"#DIV/0!"}},0.1,{"$f":"IF(AND(ISNUMBER(M61),ISNUMBER(M62)), M61/M62, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F60)),NOT(ISBLANK(F60))),G60-F60,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H60)),NOT(ISBLANK(H60))),I60-H60,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J60)),NOT(ISBLANK(J60))),K60-J60,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L60)),NOT(ISBLANK(L60))),M60-L60,\"\"))))","v":{"$error":"#DIV/0!"}}]
["GG1.22(1)","Number of vacant posts filled within 6 months since the date (dd/mm/yyyy) of authority to proceed with filling the vacancy",null,null,null,null,19,null,0,null,0]
["GG1.22(2)","Number of vacant posts that have been filled",null,null,null,null,13,null,0,null,0]
["GG2.11","Percentage of ward committees with 6 or more ward committee members (excluding the ward councillor)",1,null,1,1,{"$f":"IF(AND(ISNUMBER(G64),ISNUMBER(G65)), G64/G65, \"\")","v":1},1,{"$f":"IF(AND(ISNUMBER(I64),ISNUMBER(I65)), I64/I65, \"\")","v":1},1,{"$f":"IF(AND(ISNUMBER(K64),ISNUMBER(K65)), K64/K65, \"\")","v":1},1,{"$f":"IF(AND(ISNUMBER(M64),ISNUMBER(M65)), M64/M65, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F63)),NOT(ISBLANK(F63))),G63-F63,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H63)),NOT(ISBLANK(H63))),I63-H63,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J63)),NOT(ISBLANK(J63))),K63-J63,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L63)),NOT(ISBLANK(L63))),M63-L63,\"\"))))","v":0}]
["GG2.11(1)","Total number of ward committees with 6 or more members",null,null,null,null,39,null,39,null,39]
["GG2.11(2)","Total number of wards",null,null,null,null,39,null,39,null,39]
["GG2.12","Percentage of wards that have held a quarterly councillor-convened community meeting",1,null,1,1,{"$f":"IF(AND(ISNUMBER(G67),ISNUMBER(G68),ISNUMBER(G69)), G67/(G68*G69), \"\")","v":7.6923076923076927E-2},1,{"$f":"IF(AND(ISNUMBER(I67),ISNUMBER(I68),ISNUMBER(I69)), I67/(I68*I69), \"\")","v":7.6923076923076927E-2},1,{"$f":"IF(AND(ISNUMBER(K67),ISNUMBER(K68),ISNUMBER(K69)), K67/(K68*K69), \"\")","v":7.6923076923076927E-2},1,{"$f":"IF(AND(ISNUMBER(M67),ISNUMBER(M68),ISNUMBER(M69)), M67/(M68*M69), \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F66)),NOT(ISBLANK(F66))),G66-F66,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H66)),NOT(ISBLANK(H66))),I66-H66,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J66)),NOT(ISBLANK(J66))),K66-J66,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L66)),NOT(ISBLANK(L66))),M66-L66,\"\"))))","v":-0.92307692307692313}]
["GG2.12(1)","Number of councillor convened ward community meetings",null,null,null,null,117,null,117,null,117]
["GG2.12(2)","Total number of wards in the municipality",null,null,null,null,39,null,39,null,39]
["GG2.12(3)","Reporting quarter",null,null,null,null,39,null,39,null,39]
["GG2.31","Percentage of official complaints responded to through the municipal complaint management system",1,null,1,1,{"$f":"IF(AND(ISNUMBER(G71),ISNUMBER(G72)), G71/G72, \"\")","v":{"$error":"#DIV/0!"}},1,{"$f":"IF(AND(ISNUMBER(I71),ISNUMBER(I72)), I71/I72, \"\")","v":1},1,{"$f":"IF(AND(ISNUMBER(K71),ISNUMBER(K72)), K71/K72, \"\")","v":{"$error":"#DIV/0!"}},100,{"$f":"IF(AND(ISNUMBER(M71),ISNUMBER(M72)), M71/M72, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F70)),NOT(ISBLANK(F70))),G70-F70,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H70)),NOT(ISBLANK(H70))),I70-H70,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J70)),NOT(ISBLANK(J70))),K70-J70,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L70)),NOT(ISBLANK(L70))),M70-L70,\"\"))))","v":{"$error":"#DIV/0!"}}]
["GG2.31(1)","Number of official complaints responded to according to municipal norms and standards",null,null,null,null,0,null,1,null,0]
["GG2.31(2)","Number of official complaints received",null,null,null,null,0,null,1,null,0]
["GG5.11","Number of active suspensions longer than three months",0,null,0,0,{"$f":"IF(ISNUMBER(G74), G74, \"\")","v":0},0,{"$f":"IF(ISNUMBER(I74), I74, \"\")","v":0},0,{"$f":"IF(ISNUMBER(K74), K74, \"\")","v":0},0,{"$f":"IF(ISNUMBER(M74), M74, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F73)),NOT(ISBLANK(F73))),G73-F73,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H73)),NOT(ISBLANK(H73))),I73-H73,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J73)),NOT(ISBLANK(J73))),K73-J73,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L73)),NOT(ISBLANK(L73))),M73-L73,\"\"))))","v":0}]
["GG5.11(1)","Simple count of the number of active suspensions in the municipality lasting more than three months",null,null,null,null,0,null,0,null,0]
["LED1.21","Number of work opportunities created through Public Employment Programmes (incl. EPWP, CWP and other related employment programmes)",3090,null,3090,3090,{"$f":"IF(AND(ISNUMBER(G76),ISNUMBER(G77)), G76+G77, \"\")","v":2508},3090,{"$f":"IF(AND(ISNUMBER(I76),ISNUMBER(I77)), I76+I77, \"\")","v":2508},3090,{"$f":"IF(AND(ISNUMBER(K76),ISNUMBER(K77)), K76+K77, \"\")","v":2998},3090,{"$f":"IF(AND(ISNUMBER(M76),ISNUMBER(M77)), M76+M77, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F75)),NOT(ISBLANK(F75))),G75-F75,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H75)),NOT(ISBLANK(H75))),I75-H75,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J75)),NOT(ISBLANK(J75))),K75-J75,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L75)),NOT(ISBLANK(L75))),M75-L75,\"\"))))","v":-92}]
["LED1.21(1)","Number of work opportunities provided by the municipality through the Expanded Public Works Programme",null,null,null,null,428,null,428,null,428]
["LED1.21(2)","Number of work opportunities provided through the Community Works Programme and other related infrastructure initiatives.",null,null,null,null,2080,null,2080,null,2570]
["LED2.12","Percentage of the municipality's operating budget spent on indigent relief for free basic services",0.1,null,0.1,0.1,{"$f":"IF(AND(ISNUMBER(G79),ISNUMBER(G80)), G79/G80, \"\")","v":0.25647846910086503},0.1,{"$f":"IF(AND(ISNUMBER(I79),ISNUMBER(I80)), I79/I80, \"\")","v":0.51834069922492443},0.1,{"$f":"IF(AND(ISNUMBER(K79),ISNUMBER(K80)), K79/K80, \"\")","v":""},10,{"$f":"IF(AND(ISNUMBER(M79),ISNUMBER(M80)), M79/M80, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F78)),NOT(ISBLANK(F78))),G78-F78,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H78)),NOT(ISBLANK(H78))),I78-H78,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J78)),NOT(ISBLANK(J78))),K78-J78,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L78)),NOT(ISBLANK(L78))),M78-L78,\"\"))))","v":{"$error":"#VALUE!"}}]
["LED2.12(1)","R-value of operating budget expenditure on free basic services",null,null,null,null,1950370,null,3941680.38,null,"R7,038,243"]
["LED2.12(2)","Total operating budget for the municipality",null,null,null,null,7604420,null,7604420,null,"R7,604,420"]
["FD1.11","Percentage compliance with the required attendance time for structural firefighting incidents",0,null,0,0,{"$f":"IF(AND(ISNUMBER(G82),ISNUMBER(G83)), G82/G83, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(I82),ISNUMBER(I83)), I82/I83, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(K82),ISNUMBER(K83)), K82/K83, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(M82),ISNUMBER(M83)), M82/M83, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F81)),NOT(ISBLANK(F81))),G81-F81,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H81)),NOT(ISBLANK(H81))),I81-H81,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J81)),NOT(ISBLANK(J81))),K81-J81,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L81)),NOT(ISBLANK(L81))),M81-L81,\"\"))))","v":{"$error":"#DIV/0!"}}]
["FD1.11(1)","Number of structural fire incidents where the attendance time was 14 minutes or less",null,null,null,null,0,null,0,null,0]
["FD1.11(2)","Total number of distress calls for structural fire incidents received",null,null,null,null,0,null,0,null,0]
["LED1.11","Percentage of total municipal operating expenditure spent on contracted service providers physically residing within the municipal area",1,null,1,1,{"$f":"IF(AND(ISNUMBER(G85),ISNUMBER(G86)), G85/G86, \"\")","v":5.865826771653543},1,{"$f":"IF(AND(ISNUMBER(I85),ISNUMBER(I86)), I85/I86, \"\")","v":2.9190786822110435},1,{"$f":"IF(AND(ISNUMBER(K85),ISNUMBER(K86)), K85/K86, \"\")","v":""},1,{"$f":"IF(AND(ISNUMBER(M85),ISNUMBER(M86)), M85/M86, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F84)),NOT(ISBLANK(F84))),G84-F84,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H84)),NOT(ISBLANK(H84))),I84-H84,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J84)),NOT(ISBLANK(J84))),K84-J84,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L84)),NOT(ISBLANK(L84))),M84-L84,\"\"))))","v":{"$error":"#VALUE!"}}]
["LED1.11(1)","R-value of operating expenditure on contracted services within the municipal area",null,null,null,null,391104000,null,391104000,null,"R429,278,000"]
["LED1.11(2)","Total municipal operating expenditure on contracted services",null,null,null,null,66675000,null,133982000,null,"R246,145,000"]
["LED3.11","Average time taken to finalise business license applications","30 days",null,"30 days","30 days",{"$f":"IF(AND(ISNUMBER(G88),ISNUMBER(G89)), G88/G89, \"\")","v":{"$error":"#DIV/0!"}},"30 days",{"$f":"IF(AND(ISNUMBER(I88),ISNUMBER(I89)), I88/I89, \"\")","v":{"$error":"#DIV/0!"}},"30 days",{"$f":"IF(AND(ISNUMBER(K88),ISNUMBER(K89)), K88/K89, \"\")","v":{"$error":"#DIV/0!"}},"30 days",{"$f":"IF(AND(ISNUMBER(M88),ISNUMBER(M89)), M88/M89, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F87)),NOT(ISBLANK(F87))),G87-F87,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H87)),NOT(ISBLANK(H87))),I87-H87,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J87)),NOT(ISBLANK(J87))),K87-J87,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L87)),NOT(ISBLANK(L87))),M87-L87,\"\"))))","v":{"$error":"#DIV/0!"}}]
["LED3.11(1)","Sum of the total working days per business application finalised",null,null,null,null,0,null,0,null,0]
["LED3.11(2)","Number of business applications finalised",null,null,null,null,0,null,0,null,0]
["LED3.31","Average number of days from the point of advertising to the letter of award per 80/20 procurement process","90 days",null,"90 days","90 days",{"$f":"IF(AND(ISNUMBER(G91),ISNUMBER(G92)), G91/G92, \"\")","v":""},"90 days",{"$f":"IF(AND(ISNUMBER(I91),ISNUMBER(I92)), I91/I92, \"\")","v":""},"90 days",{"$f":"IF(AND(ISNUMBER(K91),ISNUMBER(K92)), K91/K92, \"\")","v":{"$error":"#DIV/0!"}},"90 days",{"$f":"IF(AND(ISNUMBER(M91),ISNUMBER(M92)), M91/M92, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F90)),NOT(ISBLANK(F90))),G90-F90,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H90)),NOT(ISBLANK(H90))),I90-H90,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J90)),NOT(ISBLANK(J90))),K90-J90,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L90)),NOT(ISBLANK(L90))),M90-L90,\"\"))))","v":{"$error":"#DIV/0!"}}]
["LED3.31(1)","Sum of the number of days from the point of advertising a tender in terms of the 80/20 procurement process to the issuing of the letter of award",null,null,null,null,"90 days",null,"77 Days",null,0]
["LED3.31(2)","Total number of 80/20 tenders awarded as per the procurement process",null,null,null,null,3,null,3,null,0]
["LED3.32","Percentage of municipal payments made to service providers who submitted complete forms within 30-days of invoice submission",0.89,null,1,1,{"$f":"IF(AND(ISNUMBER(G94),ISNUMBER(G95)), G94/G95, \"\")","v":0.89750692520775621},1,{"$f":"IF(AND(ISNUMBER(I94),ISNUMBER(I95)), I94/I95, \"\")","v":6.7560975609756095},1,{"$f":"IF(AND(ISNUMBER(K94),ISNUMBER(K95)), K94/K95, \"\")","v":4.5999999999999996},1,{"$f":"IF(AND(ISNUMBER(M94),ISNUMBER(M95)), M94/M95, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F93)),NOT(ISBLANK(F93))),G93-F93,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H93)),NOT(ISBLANK(H93))),I93-H93,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J93)),NOT(ISBLANK(J93))),K93-J93,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L93)),NOT(ISBLANK(L93))),M93-L93,\"\"))))","v":3.5999999999999996}]
["LED3.32(1)","Number of municipal payments within 30-days of complete invoice receipt made to service providers",null,null,null,null,324,null,277,null,299]
["LED3.32(2)","Total number of complete invoices received (30 days or older)",null,null,null,null,361,null,41,null,65]
["FM1.11","Total Capital Expenditure as a percentage of Total Capital Budget",1,null,1,1,{"$f":"IF(AND(ISNUMBER(G97),ISNUMBER(G98)), G97/G98, \"\")","v":0.18455050608731355},1,{"$f":"IF(AND(ISNUMBER(I97),ISNUMBER(I98)), I97/I98, \"\")","v":0.43475492430436918},1,{"$f":"IF(AND(ISNUMBER(K97),ISNUMBER(K98)), K97/K98, \"\")","v":""},1,{"$f":"IF(AND(ISNUMBER(M97),ISNUMBER(M98)), M97/M98, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F96)),NOT(ISBLANK(F96))),G96-F96,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H96)),NOT(ISBLANK(H96))),I96-H96,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J96)),NOT(ISBLANK(J96))),K96-J96,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L96)),NOT(ISBLANK(L96))),M96-L96,\"\"))))","v":{"$error":"#VALUE!"}}]
["FM1.11(1)","Actual Capital Expenditure",null,null,null,null,53040000,null,124949000,null,"R176,613,000"]
["FM1.11(2)","Budgeted Capital Expenditure",null,null,null,null,287401000,null,287401000,null,"R201,989,000"]
["FM1.12","Total Operating Expenditure as a percentage of Total Operating Expenditure Budget",1,null,1,1,{"$f":"IF(AND(ISNUMBER(G100),ISNUMBER(G101)), G100/G101, \"\")","v":0.20572352047707024},1,{"$f":"IF(AND(ISNUMBER(I100),ISNUMBER(I101)), I100/I101, \"\")","v":0.38955026189970465},1,{"$f":"IF(AND(ISNUMBER(K100),ISNUMBER(K101)), K100/K101, \"\")","v":""},100,{"$f":"IF(AND(ISNUMBER(M100),ISNUMBER(M101)), M100/M101, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F99)),NOT(ISBLANK(F99))),G99-F99,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H99)),NOT(ISBLANK(H99))),I99-H99,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J99)),NOT(ISBLANK(J99))),K99-J99,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L99)),NOT(ISBLANK(L99))),M99-L99,\"\"))))","v":{"$error":"#VALUE!"}}]
["FM1.12(1)","Actual Operating Expenditure",null,null,null,null,205331000,null,388807000,null,"R611,795,000"]
["FM1.12(2)","Budgeted Operating Expenditure",null,null,null,null,998092000,null,998092000,null,"R1,034,527,000"]
["FM1.13","Total Operating Revenue as a percentage of Total Operating Revenue Budget",1,null,1,1,{"$f":"IF(AND(ISNUMBER(G103),ISNUMBER(G104)), G103/G104, \"\")","v":0.32147577505034414},1,{"$f":"IF(AND(ISNUMBER(I103),ISNUMBER(I104)), I103/I104, \"\")","v":0.58515520627281992},1,{"$f":"IF(AND(ISNUMBER(K103),ISNUMBER(K104)), K103/K104, \"\")","v":""},1,{"$f":"IF(AND(ISNUMBER(M103),ISNUMBER(M104)), M103/M104, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F102)),NOT(ISBLANK(F102))),G102-F102,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H102)),NOT(ISBLANK(H102))),I102-H102,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J102)),NOT(ISBLANK(J102))),K102-J102,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L102)),NOT(ISBLANK(L102))),M102-L102,\"\"))))","v":{"$error":"#VALUE!"}}]
["FM1.13(1)","Actual Operating Revenue",null,null,null,null,360465000,null,656124000,null,"R925,604,000"]
["FM1.13(2)","Budgeted Operating Revenue",null,null,null,null,1121282000,null,1121282000,null,"R1,034,527,000"]
["FM1.14","Service Charges and Property Rates Revenue as a percentage of Service Charges and Property Rates Revenue Budget",0.95,null,0.95,0.95,{"$f":"IF(AND(ISNUMBER(G106),ISNUMBER(G107),ISNUMBER(G108)), (G106+G107)/G108, \"\")","v":5.4046888750602956E-2},0.95,{"$f":"IF(AND(ISNUMBER(I106),ISNUMBER(I107),ISNUMBER(I108)), (I106+I107)/I108, \"\")","v":0.53300144709274277},0.95,{"$f":"IF(AND(ISNUMBER(K106),ISNUMBER(K107),ISNUMBER(K108)), (K106+K107)/K108, \"\")","v":""},0.95,{"$f":"IF(AND(ISNUMBER(M106),ISNUMBER(M107),ISNUMBER(M108)), (M106+M107)/M108, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F105)),NOT(ISBLANK(F105))),G105-F105,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H105)),NOT(ISBLANK(H105))),I105-H105,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J105)),NOT(ISBLANK(J105))),K105-J105,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L105)),NOT(ISBLANK(L105))),M105-L105,\"\"))))","v":{"$error":"#VALUE!"}}]
["FM1.14(1)","Actual Service Charges Revenue",null,null,null,null,7810000,null,129376000,null,"R23,990,000"]
["FM1.14(2)","Actual Property Rates Revenue",null,null,null,null,6868000,null,15376000,null,"R192,455,000"]
["FM1.14(3)","Budgeted Service Charges and Property Rates Revenue",null,null,null,null,271579000,null,271579000,null,289503000]
["FM3.11","Cash/Cost coverage ratio","Yes funded",null,"Yes funded","Yes Funded",{"$f":"IF(AND(ISNUMBER(G110),ISNUMBER(G111),ISNUMBER(G112),ISNUMBER(G113),ISNUMBER(G114)), (G110-G111-G112+G113)/G114, \"\")","v":""},"Yes funded",{"$f":"IF(AND(ISNUMBER(I110),ISNUMBER(I111),ISNUMBER(I112),ISNUMBER(I113),ISNUMBER(I114)), (I110-I111-I112+I113)/I114, \"\")","v":3.0917785660000008},"Yes funded",{"$f":"IF(AND(ISNUMBER(K110),ISNUMBER(K111),ISNUMBER(K112),ISNUMBER(K113),ISNUMBER(K114)), (K110-K111-K112+K113)/K114, \"\")","v":""},"Yes funded",{"$f":"IF(AND(ISNUMBER(M110),ISNUMBER(M111),ISNUMBER(M112),ISNUMBER(M113),ISNUMBER(M114)), (M110-M111-M112+M113)/M114, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F109)),NOT(ISBLANK(F109))),G109-F109,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H109)),NOT(ISBLANK(H109))),I109-H109,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J109)),NOT(ISBLANK(J109))),K109-J109,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L109)),NOT(ISBLANK(L109))),M109-L109,\"\"))))","v":{"$error":"#VALUE!"}}]
["FM3.11(1)","Cash and cash equivalent",null,null,null,null,36958614,null,40266856.980000004,null,"R56,583,763"]
["FM3.11(2)","Unspent Conditional Grants",null,null,null,null,36684000,null,90051000,null,"R66,827,276"]
["FM3.11(3)","Overdraft",null,null,null,null,"R0",null,0,null,"R0"]
["FM3.11(4)","Short Term Investment",null,null,null,null,135401000,null,235290856.98000002,null,"R157,463,708"]
["FM3.11(5)","Monthly Fixed Operational Expenditure excluding (Depreciation, Amortisation, Provision for Bad Debts, Impairment and Loss on Disposal of Assets)",null,null,null,null,60000000,null,60000000,null,"R60,000,000"]
["FM3.13","Trade payables to cash ratio",0.05,null,0.1,0.1,{"$f":"IF(AND(ISNUMBER(G116),ISNUMBER(G117)), G116/G117, \"\")","v":0.18724513684219316},0.1,{"$f":"IF(AND(ISNUMBER(I116),ISNUMBER(I117)), I116/I117, \"\")","v":0.48054542940503564},0.1,{"$f":"IF(AND(ISNUMBER(K116),ISNUMBER(K117)), K116/K117, \"\")","v":""},10,{"$f":"IF(AND(ISNUMBER(M116),ISNUMBER(M117)), M116/M117, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F115)),NOT(ISBLANK(F115))),G115-F115,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H115)),NOT(ISBLANK(H115))),I115-H115,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J115)),NOT(ISBLANK(J115))),K115-J115,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L115)),NOT(ISBLANK(L115))),M115-L115,\"\"))))","v":{"$error":"#VALUE!"}}]
["FM3.13(2)","Trade payables",null,null,null,null,14351000,null,132418000,null,"R15,902,000"]
["FM3.13(1)","Cash and cash equivalents",null,null,null,null,76642845,null,275557714,null,"R56,583,763"]
["FM3.14","Liquidity ratio",1,null,1,1,{"$f":"IF(AND(ISNUMBER(G119),ISNUMBER(G120)), G119/G120, \"\")","v":0.37373991807675427},1,{"$f":"IF(AND(ISNUMBER(I119),ISNUMBER(I120)), I119/I120, \"\")","v":1.7709592282677156},1,{"$f":"IF(AND(ISNUMBER(K119),ISNUMBER(K120)), K119/K120, \"\")","v":""},1,{"$f":"IF(AND(ISNUMBER(M119),ISNUMBER(M120)), M119/M120, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F118)),NOT(ISBLANK(F118))),G118-F118,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H118)),NOT(ISBLANK(H118))),I118-H118,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J118)),NOT(ISBLANK(J118))),K118-J118,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L118)),NOT(ISBLANK(L118))),M118-L118,\"\"))))","v":{"$error":"#VALUE!"}}]
["FM3.14(1)","Cash and cash equivalents",null,null,null,null,76642845,null,275557714,null,"R56,583,763"]
["FM3.14(2)","Current liabilities",null,null,null,null,205070000,null,155598000,null,"R161,917,000"]
["FM4.31","Creditors payment period","30 days",null,"30 days","30 days",{"$f":"IF(AND(ISNUMBER(G122),ISNUMBER(G123),ISNUMBER(G124)), G122/G123*G124, \"\")","v":{"$error":"#DIV/0!"}},"30 days",{"$f":"IF(AND(ISNUMBER(I122),ISNUMBER(I123),ISNUMBER(I124)), I122/I123*I124, \"\")","v":""},"30 days",{"$f":"IF(AND(ISNUMBER(K122),ISNUMBER(K123),ISNUMBER(K124)), K122/K123*K124, \"\")","v":""},"30 days70864",{"$f":"IF(AND(ISNUMBER(M122),ISNUMBER(M123),ISNUMBER(M124)), M122/M123*M124, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F121)),NOT(ISBLANK(F121))),G121-F121,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H121)),NOT(ISBLANK(H121))),I121-H121,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J121)),NOT(ISBLANK(J121))),K121-J121,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L121)),NOT(ISBLANK(L121))),M121-L121,\"\"))))","v":{"$error":"#VALUE!"}}]
["FM4.31(1)","Trade Creditors Outstanding",null,null,null,null,7086438955,null,5559673,null,"R15,902,000"]
["FM4.31(2)","Credit purchases (operating and capital)",null,null,null,null,0,null,"R0",null,"R0"]
["FM4.31(3)","Number of days in the reporting year to date",null,null,null,null,92,null,180,null,273]
["FM5.11","Percentage of total capital expenditure funded from own funding (Internally generated funds + Borrowings)",0.4,null,0.4,0.4,{"$f":"IF(AND(ISNUMBER(G126),ISNUMBER(G127),ISNUMBER(G128)), (G126+G127)/G128, \"\")","v":""},0.4,{"$f":"IF(AND(ISNUMBER(I126),ISNUMBER(I127),ISNUMBER(I128)), (I126+I127)/I128, \"\")","v":0.23840126771722864},0.4,{"$f":"IF(AND(ISNUMBER(K126),ISNUMBER(K127),ISNUMBER(K128)), (K126+K127)/K128, \"\")","v":""},0.4,{"$f":"IF(AND(ISNUMBER(M126),ISNUMBER(M127),ISNUMBER(M128)), (M126+M127)/M128, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F125)),NOT(ISBLANK(F125))),G125-F125,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H125)),NOT(ISBLANK(H125))),I125-H125,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J125)),NOT(ISBLANK(J125))),K125-J125,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L125)),NOT(ISBLANK(L125))),M125-L125,\"\"))))","v":{"$error":"#VALUE!"}}]
["FM5.11(1)","Internally Generated Funds",null,null,null,null,26825000,null,29788000,null,"R54,479,000"]
["FM5.11(2)","Borrowings",null,null,null,null,"R0",null,0,null,"R0"]
["FM5.11(3)","Total Capital Expenditure",null,null,null,null,53040000,null,124949000,null,"R176613000"]
["FM6.12","Percentage of awarded tenders [over R200k], published on the municipality’s website",1,null,1,1,{"$f":"IF(AND(ISNUMBER(G130),ISNUMBER(G131)), G130/G131, \"\")","v":1},1,{"$f":"IF(AND(ISNUMBER(I130),ISNUMBER(I131)), I130/I131, \"\")","v":0},1,{"$f":"IF(AND(ISNUMBER(K130),ISNUMBER(K131)), K130/K131, \"\")","v":{"$error":"#DIV/0!"}},1,{"$f":"IF(AND(ISNUMBER(M130),ISNUMBER(M131)), M130/M131, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F129)),NOT(ISBLANK(F129))),G129-F129,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H129)),NOT(ISBLANK(H129))),I129-H129,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J129)),NOT(ISBLANK(J129))),K129-J129,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L129)),NOT(ISBLANK(L129))),M129-L129,\"\"))))","v":{"$error":"#DIV/0!"}}]
["FM6.12(1)","Number of awarded tenders published on the municipality's website",null,null,null,null,10,null,0,null,0]
["FM6.12(2)","Number of awarded tenders",null,null,null,null,10,null,3,null,0]
["FM6.13","Percentage of tender cancellations",0,null,0,0,{"$f":"IF(AND(ISNUMBER(G133),ISNUMBER(G134)), G133/G134, \"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(I133),ISNUMBER(I134)), I133/I134, \"\")","v":0},0,{"$f":"IF(AND(ISNUMBER(K133),ISNUMBER(K134)), K133/K134, \"\")","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(AND(ISNUMBER(M133),ISNUMBER(M134)), M133/M134, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F132)),NOT(ISBLANK(F132))),G132-F132,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H132)),NOT(ISBLANK(H132))),I132-H132,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J132)),NOT(ISBLANK(J132))),K132-J132,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L132)),NOT(ISBLANK(L132))),M132-L132,\"\"))))","v":{"$error":"#DIV/0!"}}]
["FM6.13(1)","Number of tenders cancelled",null,null,null,null,0,null,0,null,0]
["FM6.13(2)","Total number of tenders advertised and closed",null,null,null,null,17,null,8,null,0]
["FM7.11","Debtors payment period","30 days",null,"30 days","30 days",{"$f":"IF(AND(ISNUMBER(G136),ISNUMBER(G137),ISNUMBER(G138),ISNUMBER(G139)), ((G136-G137)/G138)*G139, \"\")","v":""},"30 days",{"$f":"IF(AND(ISNUMBER(I141),ISNUMBER(I137),ISNUMBER(I138),ISNUMBER(I139)), ((I141-I137)/I138)*I139, \"\")","v":""},"30 days",{"$f":"IF(AND(ISNUMBER(K136),ISNUMBER(K137),ISNUMBER(K138),ISNUMBER(K139)), ((K136-K137)/K138)*K139, \"\")","v":""},"30 days",{"$f":"IF(AND(ISNUMBER(M136),ISNUMBER(M137),ISNUMBER(M138),ISNUMBER(M139)), ((M136-M137)/M138)*M139, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F135)),NOT(ISBLANK(F135))),G135-F135,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H135)),NOT(ISBLANK(H135))),I135-H135,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J135)),NOT(ISBLANK(J135))),K135-J135,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L135)),NOT(ISBLANK(L135))),M135-L135,\"\"))))","v":{"$error":"#VALUE!"}}]
["FM7.11(1)","Gross Debtors",null,null,null,null,549994894.29999995,null,"R 598,646,076.87",null,"R632,761,560"]
["FM7.11(2)","Bad Debt Provision",null,null,null,null,0,null,0,null,"R0"]
["FM7.11(3)","Billed Revenue",null,null,null,null,67072428.030000001,null,"R 78,912,729.55",null,"R73,622,835"]
["FM7.11(4)","Number of days in the reporting period year to date",null,null,null,null,"30 days",null,"30 days",null,"30 days"]
["FM7.12","Collection rate ratio",0.95,null,0.95,0.95,{"$f":"IF(AND(ISNUMBER(G141),ISNUMBER(G142),ISNUMBER(G143),ISNUMBER(G144)), (G141+G142-G143-G144)/G142, \"\")","v":0.95850983954241298},0.95,{"$f":"IF(AND(ISNUMBER(#REF!),ISNUMBER(I142),ISNUMBER(I143),ISNUMBER(I144)), (#REF!+I142-I143-I144)/I142, \"\")","v":""},0.95,{"$f":"IF(AND(ISNUMBER(K141),ISNUMBER(K142),ISNUMBER(K143),ISNUMBER(K144)), (K141+K142-K143-K144)/K142, \"\")","v":""},0.95,{"$f":"IF(AND(ISNUMBER(M141),ISNUMBER(M142),ISNUMBER(M143),ISNUMBER(M144)), (M141+M142-M143-M144)/M142, \"\")","v":""},{"$f":"IF(AND(B4=\"Quarter 1\",NOT(ISBLANK(F140)),NOT(ISBLANK(F140))),G140-F140,IF(AND(B4=\"Quarter 2\",NOT(ISBLANK(H140)),NOT(ISBLANK(H140))),I140-H140,IF(AND(B4=\"Quarter 3\",NOT(ISBLANK(J140)),NOT(ISBLANK(J140))),K140-J140,IF(AND(B4=\"Quarter 4\",NOT(ISBLANK(L140)),NOT(ISBLANK(L140))),M140-L140,\"\"))))","v":{"$error":"#VALUE!"}}]
["FM7.12(1)","Gross Debtors Opening Balance",null,null,null,null,547212048.20000005,null,"R 575,646,076.87",null,"R598,646,077"]
["FM7.12(2)","Billed Revenue",null,null,null,null,67072428,null,"R 78,912,729.55",null,"R73,622,835"]
["FM7.12(3)","Gross Debtors Closing Balance",null,null,null,null,549994894,null,"R 598,646,076.87",null,"R632,761,560"]
["FM7.12(4)","Bad Debts Written Off",null,null,null,null,0,null,0,null,"R0"]
["C88 Code","Description","Baseline (Annual Performance for 2024/25)","Medium term target (term of government","Annual target for 2025/26","1st Quarter planned output as per SDBIP","1st Quarter actual output","2nd Quarter planned output as per SDBIP","2nd Quarter actual output","3rd Quarter planned output as per SDBIP","3rd Quarter actual output","4th Quarter planned output as per SDBIP","4th Quarter actual output","Variation","Reason(s) for variation","Remedial action","Reasons for no data, if not provided","Steps undertaken, or to be undertaken, to provide data in the future","Estimated date when data will be available"]
["COMPLIANCE INDICATORS FOR QUARTERLY REPORTING"]
["C1","Number of signed performance agreements by the MM and section 56 managers:",7,null,null,null,7,null,7,null,7]
["C2","Number of ExCo or Mayoral Executive meetings held:",15,null,null,null,3,null,5,null,4]
["C3","Number of Council portfolio committee meetings held:",60,null,null,null,16,null,14,null,15]
["C4","Number of MPAC meetings held:",15,null,null,null,3,null,5,null,4]
["C6","Number of formal (minuted) meetings between the Mayor, Speaker and MM were held to deal with municipal matters:",17,null,null,null,3,null,4,null,3]
["C7","Number of formal (minuted) meetings - to which all senior managers were invited- held:",5,null,null,null,3,null,3,null,0]
["C8","Number of councillors completed training:",16,null,null,null,9,null,25,null,25]
["C9","Number of municipal officials completed training:",20,null,null,null,13,null,208,null,10]
["C10","Number of work stoppages occurring:",0,null,null,null,0,null,0,null,0]
["C11","Number of litigation cases instituted by the municipality:",18,null,null,null,18,null,18,null,18]
["C12","Number of litigation cases instituted against the municipality:",13,null,null,null,13,null,13,null,13]
["C13","Number of forensic investigations instituted:",0,null,null,null,0,null,0,null,0]
["C14","Number of forensic investigations concluded:",0,null,null,null,0,null,0,null,0]
["C15","Number of days of sick leave taken by employees:",231,null,null,null,35,null,166,null,102]
["C17","Number of temporary employees employed:",208,null,null,null,208,null,42,null,10]
["C18","Number of approved demonstrations in the municipal area:",0,null,null,null,0,null,0,null,0]
["C19","Number of recognised traditional and Khoi-San leaders in attendance (sum of) at all council meetings:",0,null,null,null,0,null,0,null,0]
["C20","Number of permanent environmental health practitioners employed by the municipality:",0,null,null,null,0,null,0,null,0]
["C22","Number of Council meetings held:",24,null,null,null,4,null,7,null,6]
["C23","Number of disciplinary cases for misconduct relating to fraud and corruption:",0,null,null,null,0,null,0,null,0]
["C24","Number of council meetings disrupted",0,null,null,null,0,null,0,null,0]
["C25","Number of protests reported",0,null,null,null,0,null,0,null,0]
["C26","R-value of all tenders awarded",527792826,null,null,null,31756676,null,0,null,0]
["C27","Number of all awards made in terms of Section 36 of the MFMA Municipal Supply Chain Management Regulations:",0,null,null,null,0,null,3,null,0]
["C28","R-value of all awards made in terms of Section 36 of the MFMA Municipal Supply Chain Management Regulations:",0,null,null,null,0,null,"R 1153517",null,"R0"]
["C29","Number of approved applications for rezoning a property for commercial purposes:",4,null,null,null,0,null,0,null,0]
["C30","Number of business licenses approved: ",0,null,null,null,0,null,0,null,0]
["C32","Number of positions filled with regard to municipal infrastructure: ",0,null,null,null,0,null,0,null,0]
["C33","Number of tenders over R200 000 awarded:",6,null,null,null,10,null,3,null,0]
["C34","Number of months the Municipal Managers' position has been filled (not Acting): ",28,null,null,null,31,null,31,null,34]
["C35","Number of months the Chief Financial Officers' position has been filled (not Acting): ",31,null,null,null,34,null,37,null,40]
["C36","Number of vacant posts of senior managers:",2,null,null,null,2,null,2,null,2]
["C38","Number of filled posts in the treasury and budget office:",39,null,null,null,39,null,39,null,39]
["C40","Number of filled posts in the development and planning department",3,null,null,null,3,null,3,null,3]
["C42","Number of registered engineers employed in approved posts",1,null,null,null,1,null,1,null,1]
["C43","Number of engineers employed in approved posts:",1,null,null,null,1,null,1,null,1]
["C44","Number of discliplinary cases in the municipality:",0,null,null,null,2,null,2,null,2]
["C45","Number of finalised disciplinary cases:",1,null,null,null,0,null,0,null,0]
["C47","Number of waste management posts filled:",17,null,null,null,26,null,26,null,26]
["C49","Number of electricians employed in approved posts:",4,null,null,null,4,null,4,null,4]
["C51","Number of filled water and wastewater management posts:",0,null,null,null,0,null,0,null,0]
["C56","Number of customers provided with an alternative energy supply (e.g. LPG or paraffin or biogel according to supply level standards)",0,null,null,null,0,null,0,null,0]
["C57","Number of registered electricity consumers with an embedded generation system",0,null,null,null,0,null,0,null,0]
["C58","Total non-technical electricity losses in MWh (estimate)",0,null,null,null,0,null,0,null,0]
["C59","Number of municipal buildings that consume renewable energy",0,null,null,null,0,null,0,null,0]
["C61","Total number of chemical toilets in operation",0,null,null,null,0,null,0,null,0]
["C63","Total volume of water delivered by water trucks",0,null,null,null,0,null,0,null,0]
["C64","R-value of all direct municipal vehicle operational costs for public transport",0,null,null,null,0,null,"R0",null,"R0"]
["C65","Total number of scheduled public transport access points",0,null,null,null,0,null,0,null,0]
["C67","Number of paid full-time firefighters employed by the municipality",0,null,null,null,0,null,0,null,0]
["C68","Number of part-time and firefighter reservists in the service of the municipality",0,null,null,null,0,null,0,null,0]
["C69","Number of 'displaced persons' to whom the municipality delivered assistance",0,null,null,null,0,null,0,null,0]
["C71","Number of procurement processes where disputes were raised",0,null,null,null,0,null,0,null,0]
["C73","Number of structural fires occurring in informal settlements",0,null,null,null,0,null,0,null,0]
["C74","Number of dwellings in informal settelements affected by structural fires (estimate)",0,null,null,null,0,null,0,null,0]
["C76","Number of SMMEs and informal businesses benefitting from municipal digitisation support programmes rolled out directly or in partnership with other stakeholders",0,null,null,null,0,null,0,null,0]
["C77","B-BBEE Procurement Spend on Empowering Suppliers that are at least 51% black owned based",0,null,null,null,0,null,"R0",null,"R4 570032.60"]
["C78","B-BBEE Procurement Spend on Empowering Suppliers that are at least 30% black women owned",0,null,null,null,0,null,"R0",null,"R2 786 044.21"]
["C79","B-BBEE Procurement Spend from all Empowering Suppliers based on the B-BBEE Procurement",0,null,null,null,0,null,"R0",null,"R4 570032.60"]
["C81","Number of new business license applications",10,null,null,null,30,null,27,null,6]
["C83","Number of building plans approved after first review",120,null,null,null,54,null,25,null,10]
["C84","Number of building plans submitted for review",63,null,null,null,23,null,0,null,39]
["C85","Number of business licenses renewed",0,null,null,null,0,null,0,null,0]
["C86","Number of households in the municipal area registered as indigent",266,null,null,null,266,null,266,null,266]
["C89","Number of meetings of the Excutive or Mayoral Committee postponed due to lack of quorum",0,null,null,null,0,null,0,null,0]
["C92","Number of agenda items deferred to the next council meeting",0,null,null,null,0,null,0,null,0]
["C93","Number of awards made in terms of SCM Reg 32",0,null,null,null,0,null,0,null,0]
["C94","Number of requests approved for deviation from approved procurement plan",0,null,null,null,0,null,0,null,0]
["C98","Number of building plan applications approved",120,null,null,null,54,null,47,null,10]
["C99","Number of electricity connection applications received",0,null,null,null,0,null,0,null,0]
["C100","Quarterly salary bill of suspended officials",0,null,null,null,0,null,"R0",null,"R130 000"]
["C102","Number of incidents of improper disposal of medical waste responded to by the municipality",0,null,null,null,0,null,0,null,0]
["C103","Number of notifiable medical condition investigations following the prescribed protocols",0,null,null,null,0,null,0,null,0]
["C104","Number of foodborne disease outbreak investigations following the prescribed protocols",0,null,null,null,0,null,0,null,0]
["C88 Code","Description","Baseline (Annual Performance for 2024/25)","Medium term target (term of government","Annual target for 2025/26",null,null,null,null,null,null,"Annual target for 2025/26","Annual actual performance","Variation","Reason(s) for variation","Remedial action","Reasons for no data, if not provided","Steps undertaken, or to be undertaken, to provide data in the future","Estimated date when data will be available"]
["OUTPUT INDICATORS FOR ANNUAL REPORTING"]
["ENV1.12","Percentage of AQ monitoring stations providing adequate data over a reporting year",0,null,0,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E223), \"\", E223)","v":0},{"$f":"IF(AND(ISNUMBER(M224),ISNUMBER(M225)), M224/M225, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E223), ISNUMBER(M223)),M223-E223, \"\")","v":""}]
["ENV1.12(1)","Number of fully operational AQ monitoring stations"]
["ENV1.12(2)","Total number of government owned (all spheres) monitoring stations within municipal area"]
["ENV4.11","Percentage of biodiversity priority area within the municipality",0,null,0,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E226), \"\", E226)","v":0},{"$f":"IF(AND(ISNUMBER(M227),ISNUMBER(M228)), M227/M228, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E226), ISNUMBER(M226)),M226-E226, \"\")","v":""}]
["ENV4.11(1)","Total land area in hectares classified as \"biodiversity priority areas\""]
["ENV4.11(2)","Total municipal area in hectares"]
["ENV4.21","Percentage of biodiversity priority areas protected","3,320,17 square km",null,"3,320 square km%",null,null,null,null,null,null,{"$f":"IF(ISBLANK(E229), \"\", E229)","v":"3,320 square km%"},{"$f":"IF(AND(ISNUMBER(M230),ISNUMBER(M231)), M230/M231, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E229), ISNUMBER(M229)),M229-E229, \"\")","v":""}]
["ENV4.21(1)","Area of priority biodiversity area in hectares which is protected"]
["ENV4.21(2)","Total area identified as a priority biodiversity area in hectares"]
["HS1.12","Number of serviced sites",4,null,4,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E232), \"\", E232)","v":4},{"$f":"IF(ISNUMBER(M233), M233, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E232), ISNUMBER(M232)),M232-E232, \"\")","v":""}]
["HS1.12(1)","Number of all sites serviced receiving the specified basic services."]
["HS1.31","Number of informal settlements assessed (enumerated and classified)",4,null,4,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E234), \"\", E234)","v":4},{"$f":"IF(ISNUMBER(M235), M235, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E234), ISNUMBER(M234)),M234-E234, \"\")","v":""}]
["HS1.31(1)","Number of informal settlements enumerated and classified according to the UISP categorisation, or equivalent."]
["HS2.21","Number of residential properties developed through state-subsidised human settlements programmes entering the municipal valuation roll",0,null,0,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E236), \"\", E236)","v":0},{"$f":"IF(ISNUMBER(M237), M237, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E236), ISNUMBER(M236)),M236-E236, \"\")","v":""}]
["HS2.21(1)","Number of all residential properties that have benefited from state-subsidised human settlements programmes that have entered the municipal valuation roll"]
["TR5.11","Number of scheduled public transport access points added",0,null,0,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E238), \"\", E238)","v":0},{"$f":"IF(ISNUMBER(M239), M239, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E238), ISNUMBER(M238)),M238-E238, \"\")","v":""}]
["TR5.11(1)","Number of scheduled public transport service access points added"]
["TR6.11","Percentage of unsurfaced road graded","2030 kms",null,"2030bkms",null,null,null,null,null,null,{"$f":"IF(ISBLANK(E240), \"\", E240)","v":"2030bkms"},{"$f":"IF(AND(ISNUMBER(M241),ISNUMBER(M242)), M241/M242, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E240), ISNUMBER(M240)),M240-E240, \"\")","v":""}]
["TR6.11(1)","Kilometres of municipal road graded"]
["TR6.11(2)","Kilometres of unsurfaced road network"]
["WS5.31","Percentage of total water connections metered",0,null,0,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E243), \"\", E243)","v":0},{"$f":"IF(AND(ISNUMBER(M244),ISNUMBER(M245)), M244/(M244+M245), \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E243), ISNUMBER(M243)),M243-E243, \"\")","v":""}]
["WS5.31(1)","Number of water connections metered"]
["WS5.31(2)","Number of connections unmetered"]
["GG3.12","Percentage of councillors who have declared their financial interests",1,null,1,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E246), \"\", E246)","v":1},{"$f":"IF(AND(ISNUMBER(M247),ISNUMBER(M248)), M247/M248, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E246), ISNUMBER(M246)),M246-E246, \"\")","v":""}]
["GG3.12(1)","Number of councillors that have declared their financial interests"]
["GG3.12(2)","Total number of municipal councillors"]
["FM2.21","Cash backed reserves reconciliation at year end",60669155,null,"188 260 000",null,null,null,null,null,null,{"$f":"IF(ISBLANK(E249), \"\", E249)","v":"188 260 000"},{"$f":"IF(AND(ISNUMBER(M250),ISNUMBER(M251),ISNUMBER(M252),ISNUMBER(M253),ISNUMBER(M254),ISNUMBER(M255),ISNUMBER(M256),ISNUMBER(M257),ISNUMBER(M258)), M250+M251-M252-M253-M254-M255-M256-M257-M258, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E249), ISNUMBER(M249)),M249-E249, \"\")","v":""}]
["FM2.21(1)","Actual Cash and Cash Equivalents"]
["FM2.21(2)","Long Term Investment"]
["FM2.21(3)","Unspent grants"]
["FM2.21(4)","Unspent borrowing"]
["FM2.21(5)","Statutory requirement"]
["FM2.21(6)","Working capital requirements"]
["FM2.21(7)","Other provisions"]
["FM2.21(8)","Long term investment committed"]
["FM2.21(9)","Reserves to be cash backed"]
["FM3.12","Current ratio (current assets/current liabilities)",1.4,null,1.4,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E259), \"\", E259)","v":1.4},{"$f":"IF(AND(ISNUMBER(M260),ISNUMBER(M261)), M260/M261, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E259), ISNUMBER(M259)),M259-E259, \"\")","v":""}]
["FM3.12(1)","Current assets"]
["FM3.12(2)","Current liabilities"]
["FM5.12","Percentage of total capital expenditure funded from capital conditional grants","0 .57403436",null,0.57403435999999997,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E262), \"\", E262)","v":0.57403435999999997},{"$f":"IF(AND(ISNUMBER(M263),ISNUMBER(M264)), M263/M264, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E262), ISNUMBER(M262)),M262-E262, \"\")","v":""}]
["FM5.12(1)","Total Capital Transfers (provincial and national capital conditional grants)"]
["FM5.12(2)","Total Capital Expenditure"]
["FM5.21","Percentage of total capital expenditure on renewal/upgrading of existing assets",0.109195204,null,0.109,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E265), \"\", E265)","v":0.109},{"$f":"IF(AND(ISNUMBER(M266),ISNUMBER(M267)), M266/M267, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E265), ISNUMBER(M265)),M265-E265, \"\")","v":""}]
["FM5.21(1)","Total costs of Renewal and Upgrading of Existing Assets"]
["FM5.21(2)","Total Capital Expenditure"]
["FM5.22","Renewal/Upgrading of Existing Assets as a percentage of Depreciation/Asset impairment",5.4800000000000001E-2,null,"N/A",null,null,null,null,null,null,{"$f":"IF(ISBLANK(E268), \"\", E268)","v":"N/A"},{"$f":"IF(AND(ISNUMBER(M269),ISNUMBER(M270),ISNUMBER(M271)), M269/(M270+M271), \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E268), ISNUMBER(M268)),M268-E268, \"\")","v":""}]
["FM5.22(1)","Total costs of Renewal and Upgrading of Existing Assets"]
["FM5.22(2)","Depreciation"]
["FM5.22(3)","Asset impairment)"]
["FM5.31","Repairs and Maintenance as a percentage of property, plant, equipment and investment property",9.2370830000000002E-5,null,0,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E272), \"\", E272)","v":0},{"$f":"IF(AND(ISNUMBER(M273),ISNUMBER(M274),ISNUMBER(M275)), M273/(M274+M275), \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E272), ISNUMBER(M272)),M272-E272, \"\")","v":""}]
["FM5.31(1)","Total Repairs and Maintenance Expenditure"]
["FM5.31(2)","Property, Plant and Equipment"]
["FM5.31(3)","Investment Property (Carrying Value)"]
["FM7.31","Net Surplus /Deficit Margin for Electricity",0,null,0,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E276), \"\", E276)","v":0},{"$f":"IF(AND(ISNUMBER(M277),ISNUMBER(M278)), (M277-M278)/M277, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E276), ISNUMBER(M276)),M276-E276, \"\")","v":""}]
["FM7.31(1)","Total Electricity Revenue"]
["FM7.31(2)","Total Electricity Expenditure"]
["FM7.32","Net Surplus /Deficit Margin for Water",0,null,0,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E279), \"\", E279)","v":0},{"$f":"IF(AND(ISNUMBER(M280),ISNUMBER(M281)), (M280-M281)/M280, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E279), ISNUMBER(M279)),M279-E279, \"\")","v":""}]
["FM7.32(1)","Total Water Revenue"]
["FM7.32(2)","Total Water Expenditure"]
["FM7.33","Net Surplus /Deficit Margin for Wastewater",0,null,0,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E282), \"\", E282)","v":0},{"$f":"IF(AND(ISNUMBER(M283),ISNUMBER(M284)), (M283-M284)/M283, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E282), ISNUMBER(M282)),M282-E282, \"\")","v":""}]
["FM7.33(1)","Total Sanitation and Waste Water Revenue"]
["FM7.33(2)","Total Sanitation and Waste Water Expenditure"]
["FM7.34","Net Surplus /Deficit Margin for Refuse",0,null,0,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E285), \"\", E285)","v":0},{"$f":"IF(AND(ISNUMBER(M286),ISNUMBER(M287)), (M286-M287)/M286, \"\")","v":""},{"$f":"IF(AND(ISNUMBER(E285), ISNUMBER(M285)),M285-E285, \"\")","v":""}]
["FM7.34(1)","Total Refuse Revenue"]
["FM7.34(2)","Total Refuse Expenditure"]
["C88 Code","Description","Baseline (Annual Performance for 2024/25)","Medium term target (term of government","Annual target for 2025/26",null,null,null,null,null,null,"Annual target for 2025/26","Annual actual performance","Variation","Reason(s) for variation","Remedial action","Reasons for no data, if not provided","Steps undertaken, or to be undertaken, to provide data in the future","Estimated date when data will be available"]
["OUTCOME INDICATORS FOR ANNUAL REPORTING"]
["EE4.4","Percentage total electricity losses",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M291),ISNUMBER(M292)), (M291-M292)/M291, \"\")","v":""}]
["EE4.4(1)","Electricity Purchases in kWh"]
["EE4.4(2)","Electricity Sales in kWh"]
["HS3.5","Percentage utilisation rate of community halls",0.9,0.9,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M294),ISNUMBER(M295)), M294/M295, \"\")","v":""}]
["HS3.5(1)","Sum of hours booked across all community halls in the period of assessment"]
["HS3.5(2)","Sum of available hours for all community halls in the period of assessment."]
["HS3.6","Average number of library visits per library","7 in 1 library","10 in 1 library",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M297),ISNUMBER(M298)), M297/M298, \"\")","v":""}]
["HS3.6(1)","Total number of library visits"]
["HS3.6(2)","Count of municipal libraries"]
["HS3.7","Percentage of municipal cemetery plots available",0.6,0.6,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M300),ISNUMBER(M301)), M300/M301, \"\")","v":""}]
["HS3.7(1)","Number of available municipal burial plots in active municipal cemeteries"]
["HS3.7(2)","Total capacity of all burial plots in active municipal cemeteries"]
["TR6.2","Number of potholes reported per 10kms of municipal road network","1142m2","1142m2",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M303),ISNUMBER(M304)), M303/(M304/10), \"\")","v":""}]
["TR6.2(1)","Number of potholes reported"]
["TR6.2(2)","Kilometres of surfaced municipal road network"]
["WS3.1","Frequency of sewer blockages per 100 KMs of pipeline",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M306),ISNUMBER(M307)), M306/M307*100, \"\")","v":""}]
["WS3.1(1)","Number of blockages in sewers that occurred"]
["WS3.1(2)","Total sewer length in KMs"]
["WS3.2","Frequency of water mains failures per 100 KMs of pipeline",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M309),ISNUMBER(M310)), M309/M310*100, \"\")","v":""}]
["WS3.2(1)","Number of water mains failures (including failures of valves and fittings"]
["WS3.2(2)","Total mains length (water) in KMs"]
["WS3.3","Frequency of unplanned water service interruptions",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M312),ISNUMBER(M313)), M312/M313*1000, \"\")","v":""}]
["WS3.3(1)","Number of unplanned water service interruptions"]
["WS3.3(2)","Total number of water service connections"]
["WS4.1","Percentage of drinking water samples complying to SANS241",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M315),ISNUMBER(M316)), M315/M316, \"\")","v":""}]
["WS4.1(1)","Number of water sample tests that complied with SANS 241 requirements"]
["WS4.1(2)","Total number of water sample tests undertaken"]
["WS4.2","Percentage of wastewater samples compliant to water use license conditions",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M318),ISNUMBER(M319)), M318/M319, \"\")","v":""}]
["WS4.2(1)","Number of wastewater samples tested per determinant that meet compliance to specified water use license requirements"]
["WS4.2(2)","Total wastewater samples tested for all determinants over the municipal financial year"]
["WS5.1","Percentage of non-revenue water",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M321),ISNUMBER(M322)), (M321-M322)/M321, \"\")","v":""}]
["WS5.1(1)","Number of Kilolitres Water Purchased or Purified"]
["WS5.1(2)","Number of kilolitres of water sold"]
["WS5.2","Total water losses",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M324),ISNUMBER(M325),ISNUMBER(M326)), (M324-M325)*1000/(365*M326), \"\")","v":""}]
["WS5.2(1)","System input volume"]
["WS5.2(2)","Authorised consumption"]
["WS5.2(3)","Number of service connections"]
["WS5.4","Percentage of water reused",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M328),ISNUMBER(M329),ISNUMBER(M330)), (M328+M329)/M330, \"\")","v":""}]
["WS5.4(1)","1.a Direct use of treated municipal wastewater (not including irrigation)"]
["WS5.4(2)","1.b Direct use of treated municipal wastewater for irrigation purposes"]
["WS5.4(3)","System input volume"]
["GG1.1","Percentage of municipal skills development levy recovered",1,100,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M332),ISNUMBER(M333)), M332/M333, \"\")","v":""}]
["GG1.1(1)","R-value of municipal skills development levy recovered"]
["GG1.1(2)","R-value of the total qualifying value of the municipal skills development levy"]
["GG1.2","Top management stability",0.8,80,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M335),ISNUMBER(M336)), M335/M336, \"\")","v":""}]
["GG1.2(1)","Sum of actual working days, in the reporting period, that each S56 and S57 post was occupied by a fully appointed official (not suspended or vacant) with a valid signed contract and performance agreement)"]
["GG1.2(2)","Total aggregate standard working days for all S56 and S57 Posts"]
["GG2.1","Percentage of ward committees that are functional (meet four times a year, are quorate, and have an action plan)",1,1,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M338),ISNUMBER(M339)), M338/M339, \"\")","v":""}]
["GG2.1(1)","Functional ward committees"]
["GG2.1(2)","Total number of wards"]
["GG2.2","Attendance rate of municipal council meetings by participating leaders (recognised traditional and/or Khoi-San leaders)",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M341),ISNUMBER(M342),ISNUMBER(M343)), M341/(M342*M343), \"\")","v":""}]
["GG2.2(1)","Sum of the total number of recognised traditional and Khoi-San leaders in attendance at municipal council proceedings"]
["GG2.2(2)","The total number of traditional and Khoi-San leaders within the municipality"]
["GG2.2(3)","Total number of Council meetings"]
["GG2.3","Protest incidents reported per 10 000 population",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M345),ISNUMBER(M346),ISNUMBER(M347)), (M345+M346)/M347*10000, \"\")","v":""}]
["GG2.3(1)","Simple count of all unauthorised protest incidents reported"]
["GG2.3(3)","Number of approved demonstrations"]
["GG2.3(2)","Total population of the municipality"]
["GG4.1","Percentage of councillors attending council meetings",0.97,97,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M349),ISNUMBER(M350),ISNUMBER(M351)), M349/(M350*M351), \"\")","v":""}]
["GG4.1(1)","The sum total of councillor attendance of all council meetings"]
["GG4.1(2)","The total number of council meetings"]
["GG4.1(3)","The total number of councillors in the municipality"]
["FD2.2","Fire Services function in accordance with prescribed requirements",0,0,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(M353), M353, \"\")","v":""}]
["FD2.2(2)","Number of specified conditions of fire services functionality met"]
["FM1.1","Percentage of expenditure against total budget","0,15033713%","N/A",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M355),ISNUMBER(M356)), M355/M356, \"\")","v":""}]
["FM1.1(1)","Total expenditure (operating + capital)"]
["FM1.1(2)","Total budget (operating + capital)"]
["FM2.1","Percentage of total operating revenue to finance total debt (Total Debt (Borrowing) / Total operating revenue)",0.8,"N/A",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M358),ISNUMBER(M359),ISNUMBER(M360)), M358/(M359-M360), \"\")","v":""}]
["FM2.1(1)"," Debt (Short Term Borrowing + Bank Overdraft + Short Term Lease + Long Term Borrowing + Long Term Lease)"]
["FM2.1(2)","Total Operating Revenue"]
["FM2.1(3)","Operating Conditional Grant"]
["FM2.2","Percentage change in cash backed reserves reconciliation","2.2.0%","N/A",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M362),ISNUMBER(M363)), (M362-M363)/M363, \"\")","v":""}]
["FM2.2(1)","Cash backed reserves (current year)"]
["FM2.2(2)","Cash backed reserves (previous year)"]
["FM3.1","Percentage change in cash and cash equivalent (short term)",0.54,"N/A",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M365),ISNUMBER(M366)), (M365-M366)/M366, \"\")","v":""}]
["FM3.1(1)","Cash and cash equivalent (Current year)"]
["FM3.1(2)","Cash and cash equivalent (Previous year)"]
["FM4.2","Percentage of total operating expenditure on remuneration",1.5299999999999999E-2,"N/A",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M368),ISNUMBER(M369),ISNUMBER(M370)), (M368+M369)/M370, \"\")","v":""}]
["FM4.2(1)","Employee Related Costs"]
["FM4.2(2)","Councillors' Remuneration"]
["FM4.2(3)","Total Operating Expenditure"]
["FM4.3","Percentage of total operating expenditure on contracted services",3.9600000000000003E-2,"N/A",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M372),ISNUMBER(M373)), M372/M373, \"\")","v":""}]
["FM4.3(1)","Contracted Services"]
["FM4.3(2)","Total Operating Expenditure"]
["FM5.1","Percentage change of own funding (Internally generated funds + Borrowings) to fund capital expenditure",3.5999999999999999E-3,"N/A",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M375),ISNUMBER(M376),ISNUMBER(M377),ISNUMBER(M378)), (M375+M376-M377-M378)/(M377+M378), \"\")","v":""}]
["FM5.1(1)","Internally Generated Funds (current year)"]
["FM5.1(2)","Borrowings (current year)"]
["FM5.1(3)","Internally Generated Funds (previous year)"]
["FM5.1(4)","Borrowings (previous year)"]
["FM5.2","Percentage change of renewal/upgrading of existing Assets",4.3E-3,"N/A",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M380),ISNUMBER(M381)), (M380-M381)/M381, \"\")","v":""}]
["FM5.2(1)","Total costs of Renewal and Upgrading of Existing Assets (current year)"]
["FM5.2(2)","Total costs of Renewal and Upgrading of Existing Assets (previous year)"]
["FM5.3","Percentage change of repairs and maintenance of existing infrastructure",7.4000000000000003E-3,"N/A",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M383),ISNUMBER(M384)), (M383-M384)/M384, \"\")","v":""}]
["FM5.3(1)","Repairs and maintenance expenditure (current year)"]
["FM5.3(2)","Repairs and maintenance expenditure (previous year)"]
["FM7.1","Percentage change in Gross Consumer Debtors’ (Current and Non-current)",1.21E-2,"N/A",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M386),ISNUMBER(M387)), (M386-M387)/M386, \"\")","v":""}]
["FM7.1(1)","Gross consumer debtors (previous year)"]
["FM7.1(2)","Gross consumer debtors (current year"]
["FM7.2","Percentage of Revenue Growth excluding capital grants",2.1499999999999998E-2,"N/A",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M389),ISNUMBER(M390)), (M389-M390)/M390, \"\")","v":""}]
["FM7.2(1)","Total Revenue Excluding Capital Grants (current year)"]
["FM7.2(2)","Total Revenue Excluding Capital Grants (previous year)"]
["FM7.3","Percentage of net operating surplus margin",0.14000000000000001,"N/A",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(M392),ISNUMBER(M393)), (M392-M393)/M392, \"\")","v":""}]
["FM7.3(1)","Total Operating Revenue"]
["FM7.3(2)","Total Operating Expenditure"]
["C88 Code","Description","Baseline (Annual Performance for 2024/25)","Medium term target (term of government","Annual target for 2025/26",null,null,null,null,null,null,"Annual target for 2025/26","Annual actual performance","Variation","Reason(s) for variation","Remedial action","Reasons for no data, if not provided","Steps undertaken, or to be undertaken, to provide data in the future","Estimated date when data will be available"]
["COMPLIANCE QUESTIONS FOR ANNUAL REPORTING"]
["C5","Number of recognised traditional leaders within your municipal boundary",39]
["C21","Number of approved environmental health practitioner posts in the municipality",0]
["C31","Number of approved posts in the municipality with regard to municipal infrastructure:",39]
["C37","Number of approved posts in the treasury and budget office:",39]
["C39","Number of approved posts in the development and planning department:",12]
["C41","Number of approved engineer posts in the municipality:",1]
["C46","Number of approved waste management posts in the municipality:",17]
["C48","Number of approved electrician posts in the municipality:",2]
["C50","Number of approved water and wastewater management posts in the municipality:",0]
["C52","Number of maintained sports facilities",0]
["C53","Square meters of maintained public outdoor recreation space","31468m2"]
["C54","Number of municipality-owned community halls",11]
["C60","Total number of sewer connections",0]
["C62","Total number of Ventilation Improved Pit Toilets (VIPs)",0]
["C80","Date of the last Council adopted Development Charges policy","00:00:00"]
["C82","Value of Commercial Projects Constructed by adding all of the estimated costs of construction values on building permits",0]
["C95","Number of residential properties in the billing system",7474]
["C96","Number of non-residential properties in the billing system",3307]
["C97","Number of properties in the valuation roll",1070081]
["C101","Number of dismissals for fraud and corruption",0]
["C105","Installed capacity of approved embedded generators on the municipal distribution network",0]
[]
[null,"SIGNED: MUNICIPAL MANAGER",null,null,null,null,"DATE"]

{"sheet":"Lookups","index":1,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Quarter 1","EC139: Enoch Mgijima Local Municipality"]
["Quarter 2","EC157: King Sabata Dalindyebo Local Municipality"]
["Quarter 3","FS184: Matjhabeng Local Municipality"]
["Quarter 4","FS194: Maluti-A-Phofung Local Municipality"]
[null,"FS204: Metsimaholo Local Municipality"]
[null,"GT421: Emfuleni Local Municipality"]
[null,"GT481: Mogale City Local Municipality"]
[null,"GT484: Merafong City Local Municipality"]
[null,"GT485: Rand West City Local Municipality"]
[null,"KZN216: Ray Nkonyeni Local Municipality"]
[null,"KZN225: Msunduzi Local Municipality"]
[null,"KZN238: Alfred Duma Local Municipality"]
[null,"KZN252: Newcastle Local Municipality"]
[null,"KZN282: City of uMhlathuze Local Municipality"]
[null,"KZN292: KwaDukuza Local Municipality"]
[null,"LIM331: Greater Giyani Local Municipality"]
[null,"LIM333: Greater Tzaneen Local Municipality"]
[null,"LIM334: Ba-Phalaborwa Local Municipality"]
[null,"LIM343: Thulamela Local Municipality"]
[null,"LIM344: Makhado Local Municipality"]
[null,"LIM354: Polokwane Local Municipality"]
[null,"LIM362: Lephalale Local Municipality"]
[null,"LIM367: Mogalakwena Local Municipality"]
[null,"LIM476: Fetakgomo Tubatse Local Municipality"]
[null,"MP307: Govan Mbeki Local Municipality"]
[null,"MP312: Emalahleni Local Municipality (MP)"]
[null,"MP313: Steve Tshwete Local Municipality"]
[null,"MP324: Nkomazi Local Municipality"]
[null,"MP325: Bushbuckridge Local Municipality"]
[null,"MP326: City of Mbombela Local Municipality"]
[null,"NC091: Sol Plaatje Local Municipality"]
[null,"NW372: Madibeng Local Municipality"]
[null,"NW373: Rustenburg Local Municipality"]
[null,"NW383: Mahikeng Local Municipality"]
[null,"NW403: City of Matlosana Local Municipality"]
[null,"NW405: JB Marks Local Municipality"]
[null,"WC023: Drakenstein Local Municipality"]
[null,"WC024: Stellenbosch Local Municipality"]
[null,"WC044: George Local Municipality"]